UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DgE3Stglp6WV19QskfVlS0nx9jtwM/sZlLejeO/7kqc='
WHERE
key_id = '8c7a0724aa06701fab44e07799786a2afc13961cf3260f2251ffefb7e919231a'
AND (
token = 'DgE3Stglp6WV19QskfVlS0nx9jtwM/sZlLejeO/7kqc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)