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