UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YW+EUbf18fhwe1Z+gCCElI6TuAH6rzLgEIqLBtyMWIE='
WHERE
key_id = '1a8d42b8c74256702c86e787b4eaad273e4d7b54560121d9e40ddd4ac60c1b47'
AND (
token = 'YW+EUbf18fhwe1Z+gCCElI6TuAH6rzLgEIqLBtyMWIE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)