UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'j9cnhLmGYI7Z+9l+yxjnlH4nNoDbP+FdB8lDmb1euHU='
WHERE
key_id = '45dcb321b9c7b53317d5b4c41dca7bb3a22775a231a73c3725db27b300a87ec9'
AND (
token = 'j9cnhLmGYI7Z+9l+yxjnlH4nNoDbP+FdB8lDmb1euHU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)