UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'r6yFHK/uqUQHODVjs46/49ozthgVCoCuiVHJiyv9qpw='
WHERE
key_id = '37bff1403eabdb3cb1ff8a464802bb92dac3e14c71fa877e2dd59daf31ad6d3c'
AND (
token = 'r6yFHK/uqUQHODVjs46/49ozthgVCoCuiVHJiyv9qpw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)