UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6p4gCYeKcW3aNc8ORAGI60nccOXxuzYsN68Y7ojlLic='
WHERE
key_id = '336ed1bdfdbf365c7867d84c06f62db820907ef233a4543f703c230603ae3cc1'
AND (
token = '6p4gCYeKcW3aNc8ORAGI60nccOXxuzYsN68Y7ojlLic='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)