UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cMzOsRua1nzlYRRSlfXeHoWAanF+9Ew0PhP6ldqF+yA='
WHERE
key_id = 'ea47d2041bbfbd356bc95e0b3ef4062bd3d6b68c237073e74faa6266d223ac48'
AND (
token = 'cMzOsRua1nzlYRRSlfXeHoWAanF+9Ew0PhP6ldqF+yA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)