UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '24E0/U0gyUoq9dLa2ULZcLeUv69Jb+I4O6c2HqnEkSg='
WHERE
key_id = '6dc8b7b17ba2fcb1ca1bca3e4c13153286a887b3279d2034aa5ae1c80eefe5e0'
AND (
token = '24E0/U0gyUoq9dLa2ULZcLeUv69Jb+I4O6c2HqnEkSg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)