UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gi6q/k7L4LRYyC70LuTPgnRPgBx8zdbnlrOAAtON7A0='
WHERE
key_id = '24fcb07176ad34fe09830a43e69eaa8e4f15ad0865a06c4a8203bc82feb280a0'
AND (
token = 'gi6q/k7L4LRYyC70LuTPgnRPgBx8zdbnlrOAAtON7A0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)