UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5CXiaJxFhW+Mod+DIBBdzSfg7KljLabjt+0vw8IS24M='
WHERE
key_id = 'da142c76673c988b0a11ff07a143ea668ea0ed457f3d78490a1f9f8d999ff879'
AND (
token = '5CXiaJxFhW+Mod+DIBBdzSfg7KljLabjt+0vw8IS24M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)