UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3egXsHSC1KmpzG3JB6EK+eZsZrC2oBPgDK+R7mwGhcs='
WHERE
key_id = '6b766bd788700e99bcc19dc21f8dcae7b905f4276b9f53a617ae09f4a73c1258'
AND (
token = '3egXsHSC1KmpzG3JB6EK+eZsZrC2oBPgDK+R7mwGhcs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)