UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0TYqZy4BQkaUV4J0BslERzGCUXie2t3y2xz/w9C0ji4='
WHERE
key_id = 'dd1ce97ea1253935a1ca2248d9ea9dab9d207a103a692c3e3e1050537a1d598d'
AND (
token = '0TYqZy4BQkaUV4J0BslERzGCUXie2t3y2xz/w9C0ji4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)