UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PUW1MdvnbhpTMXRO5tWdvMPP5DDs5guIs/QIv7vggdQ='
WHERE
key_id = '7b5bef98f98c7b5500178224dc0c5a211b34d2a05c6df1d06944bd2d55ac8fd4'
AND (
token = 'PUW1MdvnbhpTMXRO5tWdvMPP5DDs5guIs/QIv7vggdQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)