UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bPPv8Soy9mdjjSAvXyJPPfrZnVe901VoJydmNr1lwGM='
WHERE
key_id = '7489ad13eac9c3ec1d9074317d1c8cf641d71065e75d94d99925f08a36019bf1'
AND (
token = 'bPPv8Soy9mdjjSAvXyJPPfrZnVe901VoJydmNr1lwGM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)