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