UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1hMKnEENehqGUCskrPkrwIbiAbOCn1e3KKmAbJD6zsM='
WHERE
key_id = 'ad534e781605f81823d33175466c4971692169e2e0cf4cf13f2c2ef2f2b908ef'
AND (
token = '1hMKnEENehqGUCskrPkrwIbiAbOCn1e3KKmAbJD6zsM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)