UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'W1iSceTtFQ4NNq8LGCvdcFeZWF5oWemUD0hU8M5kyHs='
WHERE
key_id = '8478ea39696b721872bcbe152345cb581d25074c9e5e315d7c29916f500f5c87'
AND (
token = 'W1iSceTtFQ4NNq8LGCvdcFeZWF5oWemUD0hU8M5kyHs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)