UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CKtrVy193QFkIGnulggd6mTA17MjO1sQKlqIOFHQbk8='
WHERE
key_id = '54b863a1e1667629f37b348782f14074f6165c56b24d7e368d721e62cb036816'
AND (
token = 'CKtrVy193QFkIGnulggd6mTA17MjO1sQKlqIOFHQbk8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)