UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fQiGIF/xOMVwdjTRMYmSEIROOlLYK5/h28PLSycwORA='
WHERE
key_id = 'b9cd0e6125aa19b27bf86c1f23927e849a21f9143d58e20de04a67ba7c206dcc'
AND (
token = 'fQiGIF/xOMVwdjTRMYmSEIROOlLYK5/h28PLSycwORA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)