UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JFE6tEsC/nf7fKIaKIvbVNlRObb/ogoya4dq0UaL7oU='
WHERE
key_id = 'f18c9204080c379382484628befe9ab9b781da592ec5e68b6cfa450e9ab3ec76'
AND (
token = 'JFE6tEsC/nf7fKIaKIvbVNlRObb/ogoya4dq0UaL7oU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)