UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QCe5IuFhE6xS6Y0+PqL217dA1dkOpdL5rgHkujj2OIc='
WHERE
key_id = '38eb7678a6a4bfec1e092dd4d2cf906d8a799eaa536cb910d025b57916a3bb3a'
AND (
token = 'QCe5IuFhE6xS6Y0+PqL217dA1dkOpdL5rgHkujj2OIc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)