UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pSR0hmfgV/I6kfsEA3tS5IQNLYMfpE3bmrrt7nmKnjw='
WHERE
key_id = '39852167a31d865e03c87a603052c0baf1b322d97a5f14a1be26cfd204b45fc2'
AND (
token = 'pSR0hmfgV/I6kfsEA3tS5IQNLYMfpE3bmrrt7nmKnjw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)