UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3auT8BEz+YI/wYGcwOy7HfKKNRvjxy6LNm0Lmxg78qg='
WHERE
key_id = 'a0597d2d9b352830e828842887ed7cd69bf326b3487913a8be05b4a0b44d7410'
AND (
token = '3auT8BEz+YI/wYGcwOy7HfKKNRvjxy6LNm0Lmxg78qg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)