UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0tmiRKTcMFLVyi8g1KFswoyHOqj869MPEU6c80eM9fQ='
WHERE
key_id = 'c81a3a927304cdbed3048d12c216f5c8eb17f2bfd50c748dc149c3813d88bc0b'
AND (
token = '0tmiRKTcMFLVyi8g1KFswoyHOqj869MPEU6c80eM9fQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)