UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1oG+jxM1dx/jQfEtVICvyt66NtvnidBsLI+O26M6ud8='
WHERE
key_id = '3d4c325cb0c7827c8105881b809aab114fc6b21888fb8249ee4401c0813bc430'
AND (
token = '1oG+jxM1dx/jQfEtVICvyt66NtvnidBsLI+O26M6ud8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)