UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gPRLHN6l6fbqUpwV94VrBgzfrkq9P3Ic9UcgZKYBHLY='
WHERE
key_id = '312e0d0cd0bd42c113b29d4f6b3b69a3be69b8ccd34443df5e1452d9ca1a2b04'
AND (
token = 'gPRLHN6l6fbqUpwV94VrBgzfrkq9P3Ic9UcgZKYBHLY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)