UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KRkr05CW6LbjAM0R6aMKlgJtnecNi4w860YGy4Oiljc='
WHERE
key_id = 'c889091efb569c930318a2d8e6dc574e9c9eb2a157f90547dcf633b27cb339d0'
AND (
token = 'KRkr05CW6LbjAM0R6aMKlgJtnecNi4w860YGy4Oiljc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)