UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6pkTSTyiZtOazws9Yxwe1BQ9/4j+8oEi9Y3TbecbBYk='
WHERE
key_id = 'dfb17063735019592544edc756d8b10b95bdc6481d6704f70dabc1b01a652a41'
AND (
token = '6pkTSTyiZtOazws9Yxwe1BQ9/4j+8oEi9Y3TbecbBYk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)