UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dIUJqO6z2J6YflKLCxsgAItgYcFmHsgtWnJEHU6uNIc='
WHERE
key_id = 'a7484cf423d33b0d8846b5d4640e5d219ed255e88f4061bb1dfa8d80bce34d62'
AND (
token = 'dIUJqO6z2J6YflKLCxsgAItgYcFmHsgtWnJEHU6uNIc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)