UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/Bgi5+Zjnxq3jKTIJFiJddIHN4NMiOeuImROO66WbPI='
WHERE
key_id = '7eb5412373b191767d9dff31d735ea88efb301584279cc60de94fd1969973d79'
AND (
token = '/Bgi5+Zjnxq3jKTIJFiJddIHN4NMiOeuImROO66WbPI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)