UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hbfzt05Oxarl1vvx1xwM84BhVYyBt4yPIKjQdfWgr20='
WHERE
key_id = '1e47108d845529205317a70ea4d090480e79b55da6adbb59d6854f5f7b1670e5'
AND (
token = 'hbfzt05Oxarl1vvx1xwM84BhVYyBt4yPIKjQdfWgr20='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)