UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zD/oCTXJHiC0g8gcroI5q74I8Rj95OsKF7ogsCj7KnA='
WHERE
key_id = '21bef7600d52f629188812b0be9d6e96968d58aea9bb34658405a650e1c00339'
AND (
token = 'zD/oCTXJHiC0g8gcroI5q74I8Rj95OsKF7ogsCj7KnA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)