UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Q0cObdVKCaDzSo16oOhEw2K18GpGrRP/+eEsswS9PYc='
WHERE
key_id = '5583943f277e6b1a4eae2f5b7f18c729c43eee66d14204934d3979395635adf1'
AND (
token = 'Q0cObdVKCaDzSo16oOhEw2K18GpGrRP/+eEsswS9PYc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)